package com.eascs.afterloan.dao;

import org.springframework.stereotype.Repository;

import com.eascs.admin.common.dao.BaseO2oDao;
import com.eascs.gaczcontract.entity.O2oLoanapply;

@Repository
public class RefundConCodeDao extends BaseO2oDao{
	
	public O2oLoanapply findLoanapplyByCode(String billCode){
		String sql = "select * from o2o_loanapply o where o.bill_code = ?";
		return this.findEntity(sql, O2oLoanapply.class, billCode);
	}
	
	public String findBankByCode(String billCode){
		String sql = "select o.loan_bank from o2o_bank_loan_data o where o.bill_code = ?";
		return this.findString(sql, billCode);
	}
}
